<%-- 
    Document   : listfield
    Created on : Apr 9, 2011, 10:35:06 PM
    Author     : Duc Quyen
--%>

 <%@page import="Model.ConnectDatabase"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%--<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%

            try {
               // Connection con1 = ConnectDatabase.getConnection();
                Statement sta2 = con.createStatement();
                ResultSet resBranch = sta2.executeQuery("select * from branch");
                while (resBranch.next()) {
%>
<option value="<%=resBranch.getInt(1)%>"><%=resBranch.getString(2)%></option>
<%              }

            } catch (SQLException s) {
                s.printStackTrace();
            }
            %>
